Alejandro Pérez's profile

EXCEL VBA | WORD VBA

DESCRIPTION: 
Custom and dynamic form for data entry to ROGERS users. 
Display of calendars to enter dates and export data entered into different excel files according to the user's selection.

DESCRIPTION: 
A simulation of a Inventory Control Model, based on philosophy Q, s, R (Q reorder, s level and R review). 
Allow a control of replenishments, backorders and deliveries of the Inventory, as well as the associated costs with the process.
DESCRIPTION:
Predictive model of football (Dutch league) developed entirely in Excel vba, received information from online database and was able to predict mainly the Under/Over 2.5 with a accuracy of 70% the matches of the day. Later he was also able to predict the winner of each game. Based on different models such as: Elo rating, Poisson, kelly criteria and others.
DESCRIPTION: 
Simple program in Excel VBA that generates a PowerPoint presentation. 
An efficient and fast way to make presentations of tables/graphs in Excel.
DESCRIPTION: 
Function programmed in Excel vba that obtains the distance (km) between two addresses using the Google Maps API.
DESCRIPTION: 
Excel VBA program that allows you to select an example graphic, by means of a range of dates and values. 
After, the Macro searches automatically for the most similar graphic and shows it as a result.
DESCRIPTION: 
The program will read the information on the sheet entered in cell B3 (Data sheet) and export the data in the sheet inserted in cell B4 (Write in), each time you press the "RUN" button, the data is added in the next column of this page.
EXCEL VBA | WORD VBA
Published:

EXCEL VBA | WORD VBA

Published: